﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace QualitySupervision.Migrations
{
    public partial class _6 : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "MobileAccruals",
                columns: table => new
                {
                    ID = table.Column<int>(nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Shi = table.Column<string>(nullable: true),
                    Qu = table.Column<string>(nullable: true),
                    BusinessName = table.Column<string>(nullable: true),
                    ProjectNo = table.Column<string>(nullable: true),
                    ProjectName = table.Column<string>(nullable: true),
                    CustomerName = table.Column<string>(nullable: true),
                    ContractStartTime = table.Column<string>(nullable: true),
                    ContractEndTime = table.Column<string>(nullable: true),
                    IncomeTime = table.Column<DateTime>(nullable: true),
                    ContractTotal = table.Column<string>(nullable: true),
                    IncomeAmount = table.Column<string>(nullable: true),
                    Tax = table.Column<string>(nullable: true),
                    AcceptTime = table.Column<string>(nullable: true),
                    StartAllocationTime = table.Column<string>(nullable: true),
                    EndAllocationTime = table.Column<string>(nullable: true),
                    MonthAllocationTime = table.Column<string>(nullable: true),
                    CumulativeAllocationTime = table.Column<string>(nullable: true),
                    NotMonthAllocationTime = table.Column<string>(nullable: true),
                    MonthIncomeAmount = table.Column<string>(nullable: true),
                    MonthActualIncomeAmount = table.Column<string>(nullable: true),
                    CumulativeIncomeAmount = table.Column<string>(nullable: true),
                    CumulativeActualIncomeAmount = table.Column<string>(nullable: true),
                    MonthArrears = table.Column<string>(nullable: true),
                    LossAmount = table.Column<string>(nullable: true),
                    CollectAmount = table.Column<string>(nullable: true),
                    EarliestArrearsMonth = table.Column<string>(nullable: true),
                    FinancialAccount = table.Column<string>(nullable: true),
                    Industry = table.Column<string>(nullable: true),
                    ProductKind = table.Column<string>(nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_MobileAccruals", x => x.ID);
                });
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "MobileAccruals");
        }
    }
}
